package com.cleaningcloud.cld.mapper;

import java.util.List;
import com.cleaningcloud.cld.domain.CldDegreetitleProject;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;

/**
 * 满意度发起项目Mapper接口
 * 
 * @author cleaningcloud
 * @date 2024-10-27
 */
public interface CldDegreetitleProjectMapper 
{
    /**
     * 查询满意度发起项目
     * 
     * @param degreetitleProjectId 满意度发起项目主键
     * @return 满意度发起项目
     */
    CldDegreetitleProject selectCldDegreetitleProjectByDegreetitleProjectId(Long degreetitleProjectId);

    /**
     * 查询满意度发起项目列表
     * 
     * @param cldDegreetitleProject 满意度发起项目
     * @return 满意度发起项目集合
     */
    List<CldDegreetitleProject> selectCldDegreetitleProjectList(CldDegreetitleProject cldDegreetitleProject);

    /**
     * 新增满意度发起项目
     * 
     * @param cldDegreetitleProject 满意度发起项目
     * @return 结果
     */
    int insertCldDegreetitleProject(CldDegreetitleProject cldDegreetitleProject);

    /**
     * 修改满意度发起项目
     * 
     * @param cldDegreetitleProject 满意度发起项目
     * @return 结果
     */
    int updateCldDegreetitleProject(CldDegreetitleProject cldDegreetitleProject);

    /**
     * 删除满意度发起项目
     * 
     * @param degreetitleProjectId 满意度发起项目主键
     * @return 结果
     */
    int deleteCldDegreetitleProjectByDegreetitleProjectId(Long degreetitleProjectId);

    /**
     * 批量删除满意度发起项目
     * 
     * @param degreetitleProjectIds 需要删除的数据主键集合
     * @return 结果
     */
    int deleteCldDegreetitleProjectByDegreetitleProjectIds(Long[] degreetitleProjectIds);


    /**
     * 根据问卷主题删除
     * @param degreetitleId
     * @return
     */
    @Delete("delete from cld_degreetitle_project where degreetitle_id = #{degreetitleId}")
    int deleteCldDegreetitleProjectByDegreetitleId(Long degreetitleId);

    /**
     * 发起调查项目
     * @param list
     */
    void batchCldDegreetitleProject(@Param("list") List<CldDegreetitleProject> list);
}
